﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="BillingDataSet" targetNamespace="http://tempuri.org/BillingDataSet.xsd" xmlns:mstns="http://tempuri.org/BillingDataSet.xsd" xmlns="http://tempuri.org/BillingDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="BillingConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="BillingConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DGTestApp.Properties.Settings.GlobalReference.Default.BillingConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientsViewTableAdapter" GeneratorDataComponentClassName="ClientsViewTableAdapter" Name="ClientsView" UserDataComponentName="ClientsViewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BillingConnectionString (Settings)" DbObjectName="Billing.dbo.ClientsView" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 20 ID, IdentificationNumber, Name, Address, Email, ContactPhone, MobilePhone, ClientStatusID, ClientStatus, Balance, ClientTypeID, ClientType, TaxID, Tax, ContractDate, ContractNumber, ModifiedDate, CreatorID, UserFullName, UserName, CreatedDate FROM dbo.ClientsView</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="IdentificationNumber" DataSetColumn="IdentificationNumber" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="ContactPhone" DataSetColumn="ContactPhone" />
              <Mapping SourceColumn="MobilePhone" DataSetColumn="MobilePhone" />
              <Mapping SourceColumn="ClientStatusID" DataSetColumn="ClientStatusID" />
              <Mapping SourceColumn="ClientStatus" DataSetColumn="ClientStatus" />
              <Mapping SourceColumn="Balance" DataSetColumn="Balance" />
              <Mapping SourceColumn="ClientTypeID" DataSetColumn="ClientTypeID" />
              <Mapping SourceColumn="ClientType" DataSetColumn="ClientType" />
              <Mapping SourceColumn="TaxID" DataSetColumn="TaxID" />
              <Mapping SourceColumn="Tax" DataSetColumn="Tax" />
              <Mapping SourceColumn="ContractDate" DataSetColumn="ContractDate" />
              <Mapping SourceColumn="ContractNumber" DataSetColumn="ContractNumber" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="CreatorID" DataSetColumn="CreatorID" />
              <Mapping SourceColumn="UserFullName" DataSetColumn="UserFullName" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="BillingDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="BillingDataSet" msprop:Generator_DataSetName="BillingDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ClientsView" msprop:Generator_UserTableName="ClientsView" msprop:Generator_RowDeletedName="ClientsViewRowDeleted" msprop:Generator_RowChangedName="ClientsViewRowChanged" msprop:Generator_RowClassName="ClientsViewRow" msprop:Generator_RowChangingName="ClientsViewRowChanging" msprop:Generator_RowEvArgName="ClientsViewRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientsViewRowChangeEventHandler" msprop:Generator_TableClassName="ClientsViewDataTable" msprop:Generator_TableVarName="tableClientsView" msprop:Generator_RowDeletingName="ClientsViewRowDeleting" msprop:Generator_TablePropName="ClientsView">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="IdentificationNumber" msprop:Generator_UserColumnName="IdentificationNumber" msprop:Generator_ColumnVarNameInTable="columnIdentificationNumber" msprop:Generator_ColumnPropNameInRow="IdentificationNumber" msprop:Generator_ColumnPropNameInTable="IdentificationNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_UserColumnName="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactPhone" msprop:Generator_UserColumnName="ContactPhone" msprop:Generator_ColumnVarNameInTable="columnContactPhone" msprop:Generator_ColumnPropNameInRow="ContactPhone" msprop:Generator_ColumnPropNameInTable="ContactPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MobilePhone" msprop:Generator_UserColumnName="MobilePhone" msprop:Generator_ColumnVarNameInTable="columnMobilePhone" msprop:Generator_ColumnPropNameInRow="MobilePhone" msprop:Generator_ColumnPropNameInTable="MobilePhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientStatusID" msprop:Generator_UserColumnName="ClientStatusID" msprop:Generator_ColumnVarNameInTable="columnClientStatusID" msprop:Generator_ColumnPropNameInRow="ClientStatusID" msprop:Generator_ColumnPropNameInTable="ClientStatusIDColumn" type="xs:short" />
              <xs:element name="ClientStatus" msprop:Generator_UserColumnName="ClientStatus" msprop:Generator_ColumnVarNameInTable="columnClientStatus" msprop:Generator_ColumnPropNameInRow="ClientStatus" msprop:Generator_ColumnPropNameInTable="ClientStatusColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Balance" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Balance" msprop:Generator_ColumnVarNameInTable="columnBalance" msprop:Generator_ColumnPropNameInRow="Balance" msprop:Generator_ColumnPropNameInTable="BalanceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ClientTypeID" msprop:Generator_UserColumnName="ClientTypeID" msprop:Generator_ColumnVarNameInTable="columnClientTypeID" msprop:Generator_ColumnPropNameInRow="ClientTypeID" msprop:Generator_ColumnPropNameInTable="ClientTypeIDColumn" type="xs:short" />
              <xs:element name="ClientType" msprop:Generator_UserColumnName="ClientType" msprop:Generator_ColumnVarNameInTable="columnClientType" msprop:Generator_ColumnPropNameInRow="ClientType" msprop:Generator_ColumnPropNameInTable="ClientTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaxID" msprop:Generator_UserColumnName="TaxID" msprop:Generator_ColumnVarNameInTable="columnTaxID" msprop:Generator_ColumnPropNameInRow="TaxID" msprop:Generator_ColumnPropNameInTable="TaxIDColumn" type="xs:short" />
              <xs:element name="Tax" msprop:Generator_UserColumnName="Tax" msprop:Generator_ColumnVarNameInTable="columnTax" msprop:Generator_ColumnPropNameInRow="Tax" msprop:Generator_ColumnPropNameInTable="TaxColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContractDate" msprop:Generator_UserColumnName="ContractDate" msprop:Generator_ColumnVarNameInTable="columnContractDate" msprop:Generator_ColumnPropNameInRow="ContractDate" msprop:Generator_ColumnPropNameInTable="ContractDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContractNumber" msprop:Generator_UserColumnName="ContractNumber" msprop:Generator_ColumnVarNameInTable="columnContractNumber" msprop:Generator_ColumnPropNameInRow="ContractNumber" msprop:Generator_ColumnPropNameInTable="ContractNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="CreatorID" msprop:Generator_UserColumnName="CreatorID" msprop:Generator_ColumnVarNameInTable="columnCreatorID" msprop:Generator_ColumnPropNameInRow="CreatorID" msprop:Generator_ColumnPropNameInTable="CreatorIDColumn" type="xs:int" />
              <xs:element name="UserFullName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="UserFullName" msprop:Generator_ColumnVarNameInTable="columnUserFullName" msprop:Generator_ColumnPropNameInRow="UserFullName" msprop:Generator_ColumnPropNameInTable="UserFullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="101" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_UserColumnName="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreatedDate" msprop:Generator_UserColumnName="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ClientsView" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>